Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	51290
Missing cells	41296
Missing cells (%)	3.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.4 MiB
Average record size in memory	192.0 B

Variable types

CAT	15
NUM	7
DATE	2

Warnings

`Order ID` has a high cardinality: 25728 distinct values	High cardinality
`Customer ID` has a high cardinality: 17415 distinct values	High cardinality
`Customer Name` has a high cardinality: 796 distinct values	High cardinality
`City` has a high cardinality: 3650 distinct values	High cardinality
`State` has a high cardinality: 1102 distinct values	High cardinality
`Country` has a high cardinality: 165 distinct values	High cardinality
`Product ID` has a high cardinality: 3788 distinct values	High cardinality
`Product Name` has a high cardinality: 3788 distinct values	High cardinality
`Market` is highly correlated with `Region`	High correlation
`Region` is highly correlated with `Market`	High correlation
`Sub-Category` is highly correlated with `Category`	High correlation
`Category` is highly correlated with `Sub-Category`	High correlation
`Postal Code` has 41296 (80.5%) missing values	Missing
`Row ID` has unique values	Unique
`Discount` has 29009 (56.6%) zeros	Zeros
`Profit` has 668 (1.3%) zeros	Zeros

Reproduction

Analysis started	2021-02-20 07:00:16.909718
Analysis finished	2021-02-20 07:00:31.200671
Duration	14.29 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

Row ID
Real number (ℝ_≥0)

UNIQUE

Distinct	51290
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	25645.5
Minimum	1
Maximum	51290
Zeros	0
Zeros (%)	0.0%
Memory size	400.7 KiB

Quantile statistics

Minimum	1
5-th percentile	2565.45
Q1	12823.25
median	25645.5
Q3	38467.75
95-th percentile	48725.55
Maximum	51290
Range	51289
Interquartile range (IQR)	25644.5

Descriptive statistics

Standard deviation	14806.29199
Coefficient of variation (CV)	0.577344641
Kurtosis	-1.2
Mean	25645.5
Median Absolute Deviation (MAD)	12822.5
Skewness	1.802083994 × 10¹⁷
Sum	1315357695
Variance	219226282.5
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
35460	1	< 0.1%
661	1	< 0.1%
2708	1	< 0.1%
12947	1	< 0.1%
14994	1	< 0.1%
8849	1	< 0.1%
10896	1	< 0.1%
49805	1	< 0.1%
37511	1	< 0.1%
Other values (51280)	51280	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
51290	1	< 0.1%
51289	1	< 0.1%
51288	1	< 0.1%
51287	1	< 0.1%
51286	1	< 0.1%

Order ID
Categorical

HIGH CARDINALITY

Distinct	25728
Distinct (%)	50.2%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

CA-2015-SV20365140-42268	14
TO-2015-AB600131-42299	13
IN-2013-TB21055113-41562	13
MX-2015-PO1885082-42279	13
IN-2014-MH1778527-41697	13
Other values (25723)	51224

Length

Max length	24
Median length	23
Mean length	23.11403782
Min length	20

Characters and Unicode

Total characters	1185519
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12935 ?
Unique (%)	25.2%

Sample

1st row	CA-2014-AB10015140-41954
2nd row	IN-2014-JR162107-41675
3rd row	IN-2014-CR127307-41929
4th row	ES-2014-KM1637548-41667
5th row	SG-2014-RH9495111-41948

Value	Count	Frequency (%)
CA-2015-SV20365140-42268	14	< 0.1%
TO-2015-AB600131-42299	13	< 0.1%
IN-2013-TB21055113-41562	13	< 0.1%
MX-2015-PO1885082-42279	13	< 0.1%
IN-2014-MH1778527-41697	13	< 0.1%
NI-2015-TC1098095-42033	13	< 0.1%
IN-2015-BE1133527-42276	12	< 0.1%
CA-2015-AC10615140-42250	12	< 0.1%
IN-2012-SP2062011-41262	12	< 0.1%
MX-2014-RA1988551-41795	12	< 0.1%
Other values (25718)	51163	99.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
ca-2015-sv20365140-42268	14	< 0.1%
ni-2015-tc1098095-42033	13	< 0.1%
in-2013-tb21055113-41562	13	< 0.1%
in-2014-mh1778527-41697	13	< 0.1%
mx-2015-po1885082-42279	13	< 0.1%
to-2015-ab600131-42299	13	< 0.1%
mx-2014-jk1537082-41907	12	< 0.1%
in-2015-be1133527-42276	12	< 0.1%
in-2012-sp2062011-41262	12	< 0.1%
ca-2015-ac10615140-42250	12	< 0.1%
Other values (25718)	51163	99.8%

Most occurring characters

Value	Count	Frequency (%)
1	180858	15.3%
-	153870	13.0%
2	127701	10.8%
0	125028	10.5%
4	112321	9.5%
5	81447	6.9%
3	52327	4.4%
8	40586	3.4%
9	38522	3.2%
7	34486	2.9%
Other values (30)	238373	20.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	826489	69.7%
Uppercase Letter	204953	17.3%
Dash Punctuation	153870	13.0%
Lowercase Letter	207	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
S	22610	11.0%
C	18031	8.8%
M	17510	8.5%
A	15726	7.7%
I	15561	7.6%
E	11955	5.8%
N	11166	5.4%
D	9944	4.9%
B	8607	4.2%
T	8484	4.1%
Other values (16)	65359	31.9%

Value	Count	Frequency (%)
1	180858	21.9%
2	127701	15.5%
0	125028	15.1%
4	112321	13.6%
5	81447	9.9%
3	52327	6.3%
8	40586	4.9%
9	38522	4.7%
7	34486	4.2%
6	33213	4.0%

Value	Count	Frequency (%)
p	81	39.1%
o	68	32.9%
l	58	28.0%

Value	Count	Frequency (%)
-	153870	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	980359	82.7%
Latin	205160	17.3%

Most frequent character per script

Value	Count	Frequency (%)
S	22610	11.0%
C	18031	8.8%
M	17510	8.5%
A	15726	7.7%
I	15561	7.6%
E	11955	5.8%
N	11166	5.4%
D	9944	4.8%
B	8607	4.2%
T	8484	4.1%
Other values (19)	65566	32.0%

Value	Count	Frequency (%)
1	180858	18.4%
-	153870	15.7%
2	127701	13.0%
0	125028	12.8%
4	112321	11.5%
5	81447	8.3%
3	52327	5.3%
8	40586	4.1%
9	38522	3.9%
7	34486	3.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1185519	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	180858	15.3%
-	153870	13.0%
2	127701	10.8%
0	125028	10.5%
4	112321	9.5%
5	81447	6.9%
3	52327	4.4%
8	40586	3.4%
9	38522	3.2%
7	34486	2.9%
Other values (30)	238373	20.1%

Order Date
Date

Distinct	1430
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Minimum	2012-01-01 00:00:00
Maximum	2015-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Ship Date
Date

Distinct	1464
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Minimum	2012-01-03 00:00:00
Maximum	2016-01-07 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Ship Mode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Standard Class	30775
Second Class	10309
First Class	7505
Same Day	2701

Length

Max length	14
Median length	14
Mean length	12.84306882
Min length	8

Characters and Unicode

Total characters	658721
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	First Class
2nd row	Second Class
3rd row	First Class
4th row	First Class
5th row	Same Day

Value	Count	Frequency (%)
Standard Class	30775	60.0%
Second Class	10309	20.1%
First Class	7505	14.6%
Same Day	2701	5.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
class	48589	47.4%
standard	30775	30.0%
second	10309	10.0%
first	7505	7.3%
day	2701	2.6%
same	2701	2.6%

Most occurring characters

Value	Count	Frequency (%)
a	115541	17.5%
s	104683	15.9%
d	71859	10.9%
	51290	7.8%
C	48589	7.4%
l	48589	7.4%
S	43785	6.6%
n	41084	6.2%
r	38280	5.8%
t	38280	5.8%
Other values (8)	56741	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	504851	76.6%
Uppercase Letter	102580	15.6%
Space Separator	51290	7.8%

Most frequent character per category

Value	Count	Frequency (%)
a	115541	22.9%
s	104683	20.7%
d	71859	14.2%
l	48589	9.6%
n	41084	8.1%
r	38280	7.6%
t	38280	7.6%
e	13010	2.6%
c	10309	2.0%
o	10309	2.0%
Other values (3)	12907	2.6%

Value	Count	Frequency (%)
C	48589	47.4%
S	43785	42.7%
F	7505	7.3%
D	2701	2.6%

Value	Count	Frequency (%)
	51290	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	607431	92.2%
Common	51290	7.8%

Most frequent character per script

Value	Count	Frequency (%)
a	115541	19.0%
s	104683	17.2%
d	71859	11.8%
C	48589	8.0%
l	48589	8.0%
S	43785	7.2%
n	41084	6.8%
r	38280	6.3%
t	38280	6.3%
e	13010	2.1%
Other values (7)	43731	7.2%

Value	Count	Frequency (%)
	51290	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	658721	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	115541	17.5%
s	104683	15.9%
d	71859	10.9%
	51290	7.8%
C	48589	7.4%
l	48589	7.4%
S	43785	6.6%
n	41084	6.2%
r	38280	5.8%
t	38280	5.8%
Other values (8)	56741	8.6%

Customer ID
Categorical

HIGH CARDINALITY

Distinct	17415
Distinct (%)	34.0%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

SV-203651406	26
WB-218501404	24
AP-109151404	23
EM-1396082	21
CS-121757	20
Other values (17410)	51176

Length

Max length	12
Median length	10
Mean length	10.30889062
Min length	7

Characters and Unicode

Total characters	528743
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6065 ?
Unique (%)	11.8%

Sample

1st row	AB-100151402
2nd row	JR-162107
3rd row	CR-127307
4th row	KM-1637548
5th row	RH-9495111

Value	Count	Frequency (%)
SV-203651406	26	0.1%
WB-218501404	24	< 0.1%
AP-109151404	23	< 0.1%
EM-1396082	21	< 0.1%
CS-121757	20	< 0.1%
JK-1609027	19	< 0.1%
RW-195401404	19	< 0.1%
YC-2189545	18	< 0.1%
TB-210551406	18	< 0.1%
RB-1933082	18	< 0.1%
Other values (17405)	51084	99.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
sv-203651406	26	0.1%
wb-218501404	24	< 0.1%
ap-109151404	23	< 0.1%
em-1396082	21	< 0.1%
cs-121757	20	< 0.1%
jk-1609027	19	< 0.1%
rw-195401404	19	< 0.1%
tb-210551406	18	< 0.1%
rb-1933082	18	< 0.1%
yc-2189545	18	< 0.1%
Other values (17405)	51084	99.6%

Most occurring characters

Value	Count	Frequency (%)
1	80165	15.2%
0	57252	10.8%
-	51290	9.7%
5	49388	9.3%
4	37214	7.0%
2	32895	6.2%
8	27651	5.2%
3	24211	4.6%
6	22351	4.2%
9	22193	4.2%
Other values (30)	124133	23.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	374873	70.9%
Uppercase Letter	102373	19.4%
Dash Punctuation	51290	9.7%
Lowercase Letter	207	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
M	9011	8.8%
C	8835	8.6%
S	8738	8.5%
B	8382	8.2%
D	6582	6.4%
J	6171	6.0%
A	5967	5.8%
H	5218	5.1%
P	5206	5.1%
R	4849	4.7%
Other values (16)	33414	32.6%

Value	Count	Frequency (%)
1	80165	21.4%
0	57252	15.3%
5	49388	13.2%
4	37214	9.9%
2	32895	8.8%
8	27651	7.4%
3	24211	6.5%
6	22351	6.0%
9	22193	5.9%
7	21553	5.7%

Value	Count	Frequency (%)
p	81	39.1%
o	68	32.9%
l	58	28.0%

Value	Count	Frequency (%)
-	51290	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	426163	80.6%
Latin	102580	19.4%

Most frequent character per script

Value	Count	Frequency (%)
M	9011	8.8%
C	8835	8.6%
S	8738	8.5%
B	8382	8.2%
D	6582	6.4%
J	6171	6.0%
A	5967	5.8%
H	5218	5.1%
P	5206	5.1%
R	4849	4.7%
Other values (19)	33621	32.8%

Value	Count	Frequency (%)
1	80165	18.8%
0	57252	13.4%
-	51290	12.0%
5	49388	11.6%
4	37214	8.7%
2	32895	7.7%
8	27651	6.5%
3	24211	5.7%
6	22351	5.2%
9	22193	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	528743	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	80165	15.2%
0	57252	10.8%
-	51290	9.7%
5	49388	9.3%
4	37214	7.0%
2	32895	6.2%
8	27651	5.2%
3	24211	4.6%
6	22351	4.2%
9	22193	4.2%
Other values (30)	124133	23.5%

Customer Name
Categorical

HIGH CARDINALITY

Distinct	796
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Muhammed Yedwab	108
Steven Ward	106
Patrick O'Brill	102
Bill Eplett	102
Gary Hwang	102
Other values (791)	50770

Length

Max length	22
Median length	13
Mean length	12.94499903
Min length	7

Characters and Unicode

Total characters	663949
Distinct characters	57
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Aaron Bergman
2nd row	Justin Ritter
3rd row	Craig Reiter
4th row	Katherine Murray
5th row	Rick Hansen

Value	Count	Frequency (%)
Muhammed Yedwab	108	0.2%
Steven Ward	106	0.2%
Patrick O'Brill	102	0.2%
Bill Eplett	102	0.2%
Gary Hwang	102	0.2%
Harry Greene	101	0.2%
Eric Murdock	100	0.2%
Art Ferguson	98	0.2%
Brosina Hoffman	97	0.2%
Chloris Kastensmidt	96	0.2%
Other values (786)	50278	98.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
michael	655	0.6%
john	522	0.5%
paul	438	0.4%
patrick	437	0.4%
tom	430	0.4%
stewart	426	0.4%
anthony	424	0.4%
frank	422	0.4%
alan	402	0.4%
bill	402	0.4%
Other values (903)	98317	95.6%

Most occurring characters

Value	Count	Frequency (%)
a	61448	9.3%
e	60921	9.2%
n	51794	7.8%
	51585	7.8%
r	48359	7.3%
i	40349	6.1%
l	34222	5.2%
o	30786	4.6%
t	27197	4.1%
s	23187	3.5%
Other values (47)	234101	35.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	506201	76.2%
Uppercase Letter	105210	15.8%
Space Separator	51585	7.8%
Other Punctuation	728	0.1%
Dash Punctuation	225	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	61448	12.1%
e	60921	12.0%
n	51794	10.2%
r	48359	9.6%
i	40349	8.0%
l	34222	6.8%
o	30786	6.1%
t	27197	5.4%
s	23187	4.6%
h	19661	3.9%
Other values (18)	108277	21.4%

Value	Count	Frequency (%)
C	9419	9.0%
M	9185	8.7%
S	8731	8.3%
B	8677	8.2%
D	6780	6.4%
A	6298	6.0%
J	6171	5.9%
H	5434	5.2%
P	5206	4.9%
R	4977	4.7%
Other values (16)	34332	32.6%

Value	Count	Frequency (%)
	51585	100.0%

Value	Count	Frequency (%)
'	728	100.0%

Value	Count	Frequency (%)
-	225	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	611411	92.1%
Common	52538	7.9%

Most frequent character per script

Value	Count	Frequency (%)
a	61448	10.1%
e	60921	10.0%
n	51794	8.5%
r	48359	7.9%
i	40349	6.6%
l	34222	5.6%
o	30786	5.0%
t	27197	4.4%
s	23187	3.8%
h	19661	3.2%
Other values (44)	213487	34.9%

Value	Count	Frequency (%)
	51585	98.2%
'	728	1.4%
-	225	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	663533	99.9%
None	416	0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	61448	9.3%
e	60921	9.2%
n	51794	7.8%
	51585	7.8%
r	48359	7.3%
i	40349	6.1%
l	34222	5.2%
o	30786	4.6%
t	27197	4.1%
s	23187	3.5%
Other values (44)	233685	35.2%

Value	Count	Frequency (%)
ö	293	70.4%
ä	76	18.3%
ü	47	11.3%

Segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Consumer	26518
Corporate	15429
Home Office	9343

Length

Max length	11
Median length	8
Mean length	8.847299669
Min length	8

Characters and Unicode

Total characters	453778
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Corporate
3rd row	Consumer
4th row	Home Office
5th row	Consumer

Value	Count	Frequency (%)
Consumer	26518	51.7%
Corporate	15429	30.1%
Home Office	9343	18.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
consumer	26518	43.7%
corporate	15429	25.4%
office	9343	15.4%
home	9343	15.4%

Most occurring characters

Value	Count	Frequency (%)
o	66719	14.7%
e	60633	13.4%
r	57376	12.6%
C	41947	9.2%
m	35861	7.9%
n	26518	5.8%
s	26518	5.8%
u	26518	5.8%
f	18686	4.1%
p	15429	3.4%
Other values (7)	77573	17.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	383802	84.6%
Uppercase Letter	60633	13.4%
Space Separator	9343	2.1%

Most frequent character per category

Value	Count	Frequency (%)
o	66719	17.4%
e	60633	15.8%
r	57376	14.9%
m	35861	9.3%
n	26518	6.9%
s	26518	6.9%
u	26518	6.9%
f	18686	4.9%
p	15429	4.0%
a	15429	4.0%
Other values (3)	34115	8.9%

Value	Count	Frequency (%)
C	41947	69.2%
H	9343	15.4%
O	9343	15.4%

Value	Count	Frequency (%)
	9343	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	444435	97.9%
Common	9343	2.1%

Most frequent character per script

Value	Count	Frequency (%)
o	66719	15.0%
e	60633	13.6%
r	57376	12.9%
C	41947	9.4%
m	35861	8.1%
n	26518	6.0%
s	26518	6.0%
u	26518	6.0%
f	18686	4.2%
p	15429	3.5%
Other values (6)	68230	15.4%

Value	Count	Frequency (%)
	9343	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	453778	100.0%

Most frequent character per block

Value	Count	Frequency (%)
o	66719	14.7%
e	60633	13.4%
r	57376	12.6%
C	41947	9.2%
m	35861	7.9%
n	26518	5.8%
s	26518	5.8%
u	26518	5.8%
f	18686	4.1%
p	15429	3.4%
Other values (7)	77573	17.1%

Postal Code
Real number (ℝ_≥0)

MISSING

Distinct	631
Distinct (%)	6.3%
Missing	41296
Missing (%)	80.5%
Infinite	0
Infinite (%)	0.0%

Mean	55190.37943
Minimum	1040
Maximum	99301
Zeros	0
Zeros (%)	0.0%
Memory size	400.7 KiB

Quantile statistics

Minimum	1040
5-th percentile	10009
Q1	23223
median	56430.5
Q3	90008
95-th percentile	98006
Maximum	99301
Range	98261
Interquartile range (IQR)	66785

Descriptive statistics

Standard deviation	32063.69335
Coefficient of variation (CV)	0.5809652639
Kurtosis	-1.493020228
Mean	55190.37943
Median Absolute Deviation (MAD)	33573.5
Skewness	-0.1285255164
Sum	551572652
Variance	1028080431
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10035	263	0.5%
10024	230	0.4%
10009	229	0.4%
94122	203	0.4%
10011	193	0.4%
94110	166	0.3%
98105	165	0.3%
19134	160	0.3%
98103	151	0.3%
90049	151	0.3%
Other values (621)	8083	15.8%
(Missing)	41296	80.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1040	1	< 0.1%
1453	6	< 0.1%
1752	2	< 0.1%
1810	4	< 0.1%
1841	33	0.1%

Value	Count	Frequency (%)
99301	6	< 0.1%
99207	7	< 0.1%
98661	5	< 0.1%
98632	3	< 0.1%
98502	5	< 0.1%

City
Categorical

HIGH CARDINALITY

Distinct	3650
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

New York City	915
Los Angeles	747
Philadelphia	537
San Francisco	510
Santo Domingo	443
Other values (3645)	48138

Length

Max length	35
Median length	8
Mean length	8.418834081
Min length	2

Characters and Unicode

Total characters	431802
Distinct characters	77
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	491 ?
Unique (%)	1.0%

Sample

1st row	Oklahoma City
2nd row	Wollongong
3rd row	Brisbane
4th row	Berlin
5th row	Dakar

Value	Count	Frequency (%)
New York City	915	1.8%
Los Angeles	747	1.5%
Philadelphia	537	1.0%
San Francisco	510	1.0%
Santo Domingo	443	0.9%
Manila	432	0.8%
Seattle	428	0.8%
Houston	377	0.7%
Tegucigalpa	362	0.7%
Jakarta	337	0.7%
Other values (3640)	46202	90.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
city	1787	2.8%
san	1672	2.6%
new	958	1.5%
york	950	1.5%
los	874	1.4%
angeles	751	1.2%
de	598	0.9%
francisco	557	0.9%
philadelphia	537	0.8%
santo	465	0.7%
Other values (3820)	54682	85.7%

Most occurring characters

Value	Count	Frequency (%)
a	55167	12.8%
n	32505	7.5%
e	31858	7.4%
o	30454	7.1%
i	27007	6.3%
r	23832	5.5%
l	21397	5.0%
s	16138	3.7%
t	15961	3.7%
u	15623	3.6%
Other values (67)	161860	37.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	354192	82.0%
Uppercase Letter	63398	14.7%
Space Separator	12541	2.9%
Dash Punctuation	1312	0.3%
Other Punctuation	349	0.1%
Open Punctuation	4	< 0.1%
Close Punctuation	4	< 0.1%
Final Punctuation	2	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	55167	15.6%
n	32505	9.2%
e	31858	9.0%
o	30454	8.6%
i	27007	7.6%
r	23832	6.7%
l	21397	6.0%
s	16138	4.6%
t	15961	4.5%
u	15623	4.4%
Other values (33)	84250	23.8%

Value	Count	Frequency (%)
S	7458	11.8%
C	7196	11.4%
M	6049	9.5%
B	4728	7.5%
L	4203	6.6%
A	4137	6.5%
P	4013	6.3%
T	2649	4.2%
D	2553	4.0%
N	2456	3.9%
Other values (17)	17956	28.3%

Value	Count	Frequency (%)
'	341	97.7%
.	8	2.3%

Value	Count	Frequency (%)
	12541	100.0%

Value	Count	Frequency (%)
-	1312	100.0%

Value	Count	Frequency (%)
(	4	100.0%

Value	Count	Frequency (%)
)	4	100.0%

Value	Count	Frequency (%)
’	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	417590	96.7%
Common	14212	3.3%

Most frequent character per script

Value	Count	Frequency (%)
a	55167	13.2%
n	32505	7.8%
e	31858	7.6%
o	30454	7.3%
i	27007	6.5%
r	23832	5.7%
l	21397	5.1%
s	16138	3.9%
t	15961	3.8%
u	15623	3.7%
Other values (60)	147648	35.4%

Value	Count	Frequency (%)
	12541	88.2%
-	1312	9.2%
'	341	2.4%
.	8	0.1%
(	4	< 0.1%
)	4	< 0.1%
’	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	429375	99.4%
None	2425	0.6%
Punctuation	2	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	55167	12.8%
n	32505	7.6%
e	31858	7.4%
o	30454	7.1%
i	27007	6.3%
r	23832	5.6%
l	21397	5.0%
s	16138	3.8%
t	15961	3.7%
u	15623	3.6%
Other values (48)	159433	37.1%

Value	Count	Frequency (%)
á	643	26.5%
í	507	20.9%
ó	410	16.9%
é	290	12.0%
ã	261	10.8%
ú	89	3.7%
ü	55	2.3%
ç	52	2.1%
ñ	34	1.4%
Á	32	1.3%
Other values (8)	52	2.1%

Value	Count	Frequency (%)
’	2	100.0%

State
Categorical

HIGH CARDINALITY

Distinct	1102
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

California	2001
England	1499
New York	1128
Texas	985
Ile-de-France	981
Other values (1097)	44696

Length

Max length	36
Median length	8
Mean length	9.997387405
Min length	3

Characters and Unicode

Total characters	512766
Distinct characters	85
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	68 ?
Unique (%)	0.1%

Sample

1st row	Oklahoma
2nd row	New South Wales
3rd row	Queensland
4th row	Berlin
5th row	Dakar

Value	Count	Frequency (%)
California	2001	3.9%
England	1499	2.9%
New York	1128	2.2%
Texas	985	1.9%
Ile-de-France	981	1.9%
New South Wales	781	1.5%
North Rhine-Westphalia	719	1.4%
Queensland	717	1.4%
San Salvador	615	1.2%
Pennsylvania	587	1.1%
Other values (1092)	41277	80.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
california	2125	3.1%
new	2103	3.1%
england	1499	2.2%
south	1201	1.8%
north	1145	1.7%
york	1128	1.7%
texas	985	1.4%
ile-de-france	981	1.4%
wales	817	1.2%
capital	784	1.1%
Other values (1200)	55441	81.3%

Most occurring characters

Value	Count	Frequency (%)
a	74178	14.5%
n	40975	8.0%
i	34897	6.8%
e	33043	6.4%
o	29586	5.8%
r	29423	5.7%
l	24353	4.7%
t	21702	4.2%
s	20399	4.0%
	16919	3.3%
Other values (75)	187291	36.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	412939	80.5%
Uppercase Letter	73884	14.4%
Space Separator	16919	3.3%
Dash Punctuation	8007	1.6%
Other Punctuation	811	0.2%
Open Punctuation	103	< 0.1%
Close Punctuation	103	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	74178	18.0%
n	40975	9.9%
i	34897	8.5%
e	33043	8.0%
o	29586	7.2%
r	29423	7.1%
l	24353	5.9%
t	21702	5.3%
s	20399	4.9%
u	15519	3.8%
Other values (40)	88864	21.5%

Value	Count	Frequency (%)
C	7952	10.8%
S	6864	9.3%
A	6031	8.2%
N	5045	6.8%
P	4439	6.0%
M	4195	5.7%
B	3613	4.9%
T	3083	4.2%
W	3017	4.1%
L	2950	4.0%
Other values (19)	26695	36.1%

Value	Count	Frequency (%)
'	764	94.2%
.	47	5.8%

Value	Count	Frequency (%)
	16919	100.0%

Value	Count	Frequency (%)
-	8007	100.0%

Value	Count	Frequency (%)
(	103	100.0%

Value	Count	Frequency (%)
)	103	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	486823	94.9%
Common	25943	5.1%

Most frequent character per script

Value	Count	Frequency (%)
a	74178	15.2%
n	40975	8.4%
i	34897	7.2%
e	33043	6.8%
o	29586	6.1%
r	29423	6.0%
l	24353	5.0%
t	21702	4.5%
s	20399	4.2%
u	15519	3.2%
Other values (69)	162748	33.4%

Value	Count	Frequency (%)
	16919	65.2%
-	8007	30.9%
'	764	2.9%
(	103	0.4%
)	103	0.4%
.	47	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	507931	99.1%
None	4713	0.9%
Latin Ext Additional	122	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	74178	14.6%
n	40975	8.1%
i	34897	6.9%
e	33043	6.5%
o	29586	5.8%
r	29423	5.8%
l	24353	4.8%
t	21702	4.3%
s	20399	4.0%
	16919	3.3%
Other values (48)	182456	35.9%

Value	Count	Frequency (%)
é	1142	24.2%
á	873	18.5%
í	712	15.1%
ô	672	14.3%
ã	472	10.0%
ó	291	6.2%
ü	260	5.5%
è	63	1.3%
à	58	1.2%
Á	30	0.6%
Other values (13)	140	3.0%

Value	Count	Frequency (%)
ủ	48	39.3%
ộ	48	39.3%
ỉ	13	10.7%
ầ	13	10.7%

Country
Categorical

HIGH CARDINALITY

Distinct	165
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

United States	9994
Australia	2837
France	2827
Mexico	2635
Germany	2063
Other values (160)	30934

Length

Max length	32
Median length	8
Mean length	8.837492689
Min length	4

Characters and Unicode

Total characters	453275
Distinct characters	56
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	United States
2nd row	Australia
3rd row	Australia
4th row	Germany
5th row	Senegal

Value	Count	Frequency (%)
United States	9994	19.5%
Australia	2837	5.5%
France	2827	5.5%
Mexico	2635	5.1%
Germany	2063	4.0%
China	1880	3.7%
United Kingdom	1633	3.2%
Brazil	1593	3.1%
India	1554	3.0%
Indonesia	1390	2.7%
Other values (155)	22884	44.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
united	11641	17.1%
states	9994	14.7%
australia	2837	4.2%
france	2827	4.2%
mexico	2635	3.9%
germany	2063	3.0%
china	1880	2.8%
kingdom	1633	2.4%
brazil	1593	2.3%
india	1554	2.3%
Other values (176)	29447	43.2%

Most occurring characters

Value	Count	Frequency (%)
a	55156	12.2%
e	43178	9.5%
i	40565	8.9%
t	40484	8.9%
n	36892	8.1%
d	21296	4.7%
r	20396	4.5%
s	18378	4.1%
	16814	3.7%
o	14464	3.2%
Other values (46)	145652	32.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	368777	81.4%
Uppercase Letter	67296	14.8%
Space Separator	16814	3.7%
Open Punctuation	136	< 0.1%
Close Punctuation	136	< 0.1%
Other Punctuation	107	< 0.1%
Dash Punctuation	9	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	55156	15.0%
e	43178	11.7%
i	40565	11.0%
t	40484	11.0%
n	36892	10.0%
d	21296	5.8%
r	20396	5.5%
s	18378	5.0%
o	14464	3.9%
l	13487	3.7%
Other values (16)	64481	17.5%

Value	Count	Frequency (%)
S	13320	19.8%
U	12131	18.0%
I	5355	8.0%
A	4815	7.2%
C	4259	6.3%
M	3710	5.5%
F	2899	4.3%
G	2805	4.2%
N	2745	4.1%
B	2344	3.5%
Other values (15)	12913	19.2%

Value	Count	Frequency (%)
	16814	100.0%

Value	Count	Frequency (%)
(	136	100.0%

Value	Count	Frequency (%)
)	136	100.0%

Value	Count	Frequency (%)
'	107	100.0%

Value	Count	Frequency (%)
-	9	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	436073	96.2%
Common	17202	3.8%

Most frequent character per script

Value	Count	Frequency (%)
a	55156	12.6%
e	43178	9.9%
i	40565	9.3%
t	40484	9.3%
n	36892	8.5%
d	21296	4.9%
r	20396	4.7%
s	18378	4.2%
o	14464	3.3%
l	13487	3.1%
Other values (41)	131777	30.2%

Value	Count	Frequency (%)
	16814	97.7%
(	136	0.8%
)	136	0.8%
'	107	0.6%
-	9	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	453275	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	55156	12.2%
e	43178	9.5%
i	40565	8.9%
t	40484	8.9%
n	36892	8.1%
d	21296	4.7%
r	20396	4.5%
s	18378	4.1%
	16814	3.7%
o	14464	3.2%
Other values (46)	145652	32.1%

Region
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Western Europe	5883
Central America	5616
Oceania	3487
Western US	3203
Southeastern Asia	3129
Other values (18)	29972

Length

Max length	17
Median length	13
Mean length	12.58159485
Min length	6

Characters and Unicode

Total characters	645310
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Central US
2nd row	Oceania
3rd row	Oceania
4th row	Western Europe
5th row	Western Africa

Value	Count	Frequency (%)
Western Europe	5883	11.5%
Central America	5616	10.9%
Oceania	3487	6.8%
Western US	3203	6.2%
Southeastern Asia	3129	6.1%
South America	2988	5.8%
Eastern US	2848	5.6%
Southern Asia	2655	5.2%
Western Asia	2440	4.8%
Eastern Asia	2374	4.6%
Other values (13)	16667	32.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
western	12986	13.4%
europe	11729	12.1%
asia	10815	11.1%
us	9994	10.3%
central	8799	9.1%
america	8604	8.9%
eastern	7479	7.7%
southern	6866	7.1%
africa	4587	4.7%
oceania	3487	3.6%
Other values (6)	11673	12.0%

Most occurring characters

Value	Count	Frequency (%)
e	83088	12.9%
r	71555	11.1%
a	54919	8.5%
t	48858	7.6%
n	47024	7.3%
	45729	7.1%
s	34409	5.3%
i	29183	4.5%
o	28194	4.4%
u	24712	3.8%
Other values (16)	177639	27.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	492568	76.3%
Uppercase Letter	107013	16.6%
Space Separator	45729	7.1%

Most frequent character per category

Value	Count	Frequency (%)
e	83088	16.9%
r	71555	14.5%
a	54919	11.1%
t	48858	9.9%
n	47024	9.5%
s	34409	7.0%
i	29183	5.9%
o	28194	5.7%
u	24712	5.0%
c	16678	3.4%
Other values (7)	53948	11.0%

Value	Count	Frequency (%)
A	24006	22.4%
S	22977	21.5%
E	19208	17.9%
W	12986	12.1%
C	10873	10.2%
U	9994	9.3%
O	3487	3.3%
N	3482	3.3%

Value	Count	Frequency (%)
	45729	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	599581	92.9%
Common	45729	7.1%

Most frequent character per script

Value	Count	Frequency (%)
e	83088	13.9%
r	71555	11.9%
a	54919	9.2%
t	48858	8.1%
n	47024	7.8%
s	34409	5.7%
i	29183	4.9%
o	28194	4.7%
u	24712	4.1%
A	24006	4.0%
Other values (15)	153633	25.6%

Value	Count	Frequency (%)
	45729	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	645310	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	83088	12.9%
r	71555	11.1%
a	54919	8.5%
t	48858	7.6%
n	47024	7.3%
	45729	7.1%
s	34409	5.3%
i	29183	4.5%
o	28194	4.4%
u	24712	3.8%
Other values (16)	177639	27.5%

Market
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Asia Pacific	14302
Europe	11729
USCA	10378
LATAM	10294
Africa	4587

Length

Max length	12
Median length	6
Mean length	7.067693508
Min length	4

Characters and Unicode

Total characters	362502
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USCA
2nd row	Asia Pacific
3rd row	Asia Pacific
4th row	Europe
5th row	Africa

Value	Count	Frequency (%)
Asia Pacific	14302	27.9%
Europe	11729	22.9%
USCA	10378	20.2%
LATAM	10294	20.1%
Africa	4587	8.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
pacific	14302	21.8%
asia	14302	21.8%
europe	11729	17.9%
usca	10378	15.8%
latam	10294	15.7%
africa	4587	7.0%

Most occurring characters

Value	Count	Frequency (%)
A	49855	13.8%
i	47493	13.1%
a	33191	9.2%
c	33191	9.2%
f	18889	5.2%
r	16316	4.5%
s	14302	3.9%
	14302	3.9%
P	14302	3.9%
E	11729	3.2%
Other values (10)	108932	30.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	210298	58.0%
Uppercase Letter	137902	38.0%
Space Separator	14302	3.9%

Most frequent character per category

Value	Count	Frequency (%)
i	47493	22.6%
a	33191	15.8%
c	33191	15.8%
f	18889	9.0%
r	16316	7.8%
s	14302	6.8%
u	11729	5.6%
o	11729	5.6%
p	11729	5.6%
e	11729	5.6%

Value	Count	Frequency (%)
A	49855	36.2%
P	14302	10.4%
E	11729	8.5%
U	10378	7.5%
S	10378	7.5%
C	10378	7.5%
L	10294	7.5%
T	10294	7.5%
M	10294	7.5%

Value	Count	Frequency (%)
	14302	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	348200	96.1%
Common	14302	3.9%

Most frequent character per script

Value	Count	Frequency (%)
A	49855	14.3%
i	47493	13.6%
a	33191	9.5%
c	33191	9.5%
f	18889	5.4%
r	16316	4.7%
s	14302	4.1%
P	14302	4.1%
E	11729	3.4%
u	11729	3.4%
Other values (9)	97203	27.9%

Value	Count	Frequency (%)
	14302	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	362502	100.0%

Most frequent character per block

Value	Count	Frequency (%)
A	49855	13.8%
i	47493	13.1%
a	33191	9.2%
c	33191	9.2%
f	18889	5.2%
r	16316	4.5%
s	14302	3.9%
	14302	3.9%
P	14302	3.9%
E	11729	3.2%
Other values (10)	108932	30.1%

Product ID
Categorical

HIGH CARDINALITY

Distinct	3788
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

OFF-FA-6129	227
OFF-BI-3737	92
OFF-ST-4057	90
OFF-ST-5693	84
OFF-BI-4828	83
Other values (3783)	50714

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	564190
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	98 ?
Unique (%)	0.2%

Sample

1st row	TEC-PH-5816
2nd row	FUR-CH-5379
3rd row	TEC-PH-5356
4th row	TEC-PH-5267
5th row	TEC-CO-6011

Value	Count	Frequency (%)
OFF-FA-6129	227	0.4%
OFF-BI-3737	92	0.2%
OFF-ST-4057	90	0.2%
OFF-ST-5693	84	0.2%
OFF-BI-4828	83	0.2%
OFF-AR-5923	80	0.2%
OFF-ST-6033	77	0.2%
OFF-BI-2917	75	0.1%
OFF-AR-6120	75	0.1%
OFF-BI-3293	74	0.1%
Other values (3778)	50333	98.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
off-fa-6129	227	0.4%
off-bi-3737	92	0.2%
off-st-4057	90	0.2%
off-st-5693	84	0.2%
off-bi-4828	83	0.2%
off-ar-5923	80	0.2%
off-st-6033	77	0.2%
off-ar-6120	75	0.1%
off-bi-2917	75	0.1%
off-bi-3293	74	0.1%
Other values (3778)	50333	98.1%

Most occurring characters

Value	Count	Frequency (%)
-	102580	18.2%
F	78193	13.9%
O	35923	6.4%
4	29191	5.2%
3	28497	5.1%
5	27577	4.9%
6	23305	4.1%
A	20722	3.7%
C	18873	3.3%
2	18188	3.2%
Other values (17)	181141	32.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	256450	45.5%
Decimal Number	205160	36.4%
Dash Punctuation	102580	18.2%

Most frequent character per category

Value	Count	Frequency (%)
F	78193	30.5%
O	35923	14.0%
A	20722	8.1%
C	18873	7.4%
T	16051	6.3%
U	15421	6.0%
R	14724	5.7%
E	12528	4.9%
P	8591	3.3%
B	8557	3.3%
Other values (6)	26867	10.5%

Value	Count	Frequency (%)
4	29191	14.2%
3	28497	13.9%
5	27577	13.4%
6	23305	11.4%
2	18188	8.9%
9	16608	8.1%
0	16205	7.9%
1	15724	7.7%
8	15303	7.5%
7	14562	7.1%

Value	Count	Frequency (%)
-	102580	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	307740	54.5%
Latin	256450	45.5%

Most frequent character per script

Value	Count	Frequency (%)
F	78193	30.5%
O	35923	14.0%
A	20722	8.1%
C	18873	7.4%
T	16051	6.3%
U	15421	6.0%
R	14724	5.7%
E	12528	4.9%
P	8591	3.3%
B	8557	3.3%
Other values (6)	26867	10.5%

Value	Count	Frequency (%)
-	102580	33.3%
4	29191	9.5%
3	28497	9.3%
5	27577	9.0%
6	23305	7.6%
2	18188	5.9%
9	16608	5.4%
0	16205	5.3%
1	15724	5.1%
8	15303	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	564190	100.0%

Most frequent character per block

Value	Count	Frequency (%)
-	102580	18.2%
F	78193	13.9%
O	35923	6.4%
4	29191	5.2%
3	28497	5.1%
5	27577	4.9%
6	23305	4.1%
A	20722	3.7%
C	18873	3.3%
2	18188	3.2%
Other values (17)	181141	32.1%

Category
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Office Supplies	31289
Technology	10141
Furniture	9860

Length

Max length	15
Median length	15
Mean length	12.85796452
Min length	9

Characters and Unicode

Total characters	659485
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Technology
2nd row	Furniture
3rd row	Technology
4th row	Technology
5th row	Technology

Value	Count	Frequency (%)
Office Supplies	31289	61.0%
Technology	10141	19.8%
Furniture	9860	19.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
office	31289	37.9%
supplies	31289	37.9%
technology	10141	12.3%
furniture	9860	11.9%

Most occurring characters

Value	Count	Frequency (%)
e	82579	12.5%
i	72438	11.0%
f	62578	9.5%
p	62578	9.5%
u	51009	7.7%
c	41430	6.3%
l	41430	6.3%
O	31289	4.7%
	31289	4.7%
S	31289	4.7%
Other values (10)	151576	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	545617	82.7%
Uppercase Letter	82579	12.5%
Space Separator	31289	4.7%

Most frequent character per category

Value	Count	Frequency (%)
e	82579	15.1%
i	72438	13.3%
f	62578	11.5%
p	62578	11.5%
u	51009	9.3%
c	41430	7.6%
l	41430	7.6%
s	31289	5.7%
o	20282	3.7%
n	20001	3.7%
Other values (5)	60003	11.0%

Value	Count	Frequency (%)
O	31289	37.9%
S	31289	37.9%
T	10141	12.3%
F	9860	11.9%

Value	Count	Frequency (%)
	31289	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	628196	95.3%
Common	31289	4.7%

Most frequent character per script

Value	Count	Frequency (%)
e	82579	13.1%
i	72438	11.5%
f	62578	10.0%
p	62578	10.0%
u	51009	8.1%
c	41430	6.6%
l	41430	6.6%
O	31289	5.0%
S	31289	5.0%
s	31289	5.0%
Other values (9)	120287	19.1%

Value	Count	Frequency (%)
	31289	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	659485	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	82579	12.5%
i	72438	11.0%
f	62578	9.5%
p	62578	9.5%
u	51009	7.7%
c	41430	6.3%
l	41430	6.3%
O	31289	4.7%
	31289	4.7%
S	31289	4.7%
Other values (10)	151576	23.0%

Sub-Category
Categorical

HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Binders	6146
Storage	5049
Art	4864
Paper	3492
Chairs	3434
Other values (12)	28305

Length

Max length	11
Median length	7
Mean length	7.236693313
Min length	3

Characters and Unicode

Total characters	371170
Distinct characters	28
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Phones
2nd row	Chairs
3rd row	Phones
4th row	Phones
5th row	Copiers

Value	Count	Frequency (%)
Binders	6146	12.0%
Storage	5049	9.8%
Art	4864	9.5%
Paper	3492	6.8%
Chairs	3434	6.7%
Phones	3357	6.5%
Furnishings	3154	6.1%
Accessories	3075	6.0%
Labels	2601	5.1%
Fasteners	2601	5.1%
Other values (7)	13517	26.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
binders	6146	12.0%
storage	5049	9.8%
art	4864	9.5%
paper	3492	6.8%
chairs	3434	6.7%
phones	3357	6.5%
furnishings	3154	6.1%
accessories	3075	6.0%
fasteners	2601	5.1%
labels	2601	5.1%
Other values (7)	13517	26.4%

Most occurring characters

Value	Count	Frequency (%)
s	52201	14.1%
e	47901	12.9%
r	34038	9.2%
i	26821	7.2%
n	24027	6.5%
a	23677	6.4%
o	20913	5.6%
p	16400	4.4%
t	12514	3.4%
c	11789	3.2%
Other values (18)	100889	27.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	319880	86.2%
Uppercase Letter	51290	13.8%

Most frequent character per category

Value	Count	Frequency (%)
s	52201	16.3%
e	47901	15.0%
r	34038	10.6%
i	26821	8.4%
n	24027	7.5%
a	23677	7.4%
o	20913	6.5%
p	16400	5.1%
t	12514	3.9%
c	11789	3.7%
Other values (8)	49599	15.5%

Value	Count	Frequency (%)
A	9681	18.9%
B	8557	16.7%
S	7456	14.5%
P	6849	13.4%
F	5755	11.2%
C	5657	11.0%
L	2601	5.1%
E	2387	4.7%
M	1486	2.9%
T	861	1.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	371170	100.0%

Most frequent character per script

Value	Count	Frequency (%)
s	52201	14.1%
e	47901	12.9%
r	34038	9.2%
i	26821	7.2%
n	24027	6.5%
a	23677	6.4%
o	20913	5.6%
p	16400	4.4%
t	12514	3.4%
c	11789	3.2%
Other values (18)	100889	27.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	371170	100.0%

Most frequent character per block

Value	Count	Frequency (%)
s	52201	14.1%
e	47901	12.9%
r	34038	9.2%
i	26821	7.2%
n	24027	6.5%
a	23677	6.4%
o	20913	5.6%
p	16400	4.4%
t	12514	3.4%
c	11789	3.2%
Other values (18)	100889	27.2%

Product Name
Categorical

HIGH CARDINALITY

Distinct	3788
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Staples	227
Cardinal Index Tab, Clear	92
Eldon File Cart, Single Width	90
Rogers File Cart, Single Width	84
Ibico Index Tab, Clear	83
Other values (3783)	50714

Length

Max length	127
Median length	29
Mean length	30.85693118
Min length	5

Characters and Unicode

Total characters	1582652
Distinct characters	85
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	98 ?
Unique (%)	0.2%

Sample

1st row	Samsung Convoy 3
2nd row	Novimex Executive Leather Armchair, Black
3rd row	Nokia Smart Phone, with Caller ID
4th row	Motorola Smart Phone, Cordless
5th row	Sharp Wireless Fax, High-Speed

Value	Count	Frequency (%)
Staples	227	0.4%
Cardinal Index Tab, Clear	92	0.2%
Eldon File Cart, Single Width	90	0.2%
Rogers File Cart, Single Width	84	0.2%
Ibico Index Tab, Clear	83	0.2%
Sanford Pencil Sharpener, Water Color	80	0.2%
Smead File Cart, Single Width	77	0.2%
Stanley Pencil Sharpener, Water Color	75	0.1%
Acco Index Tab, Clear	75	0.1%
Avery Index Tab, Clear	74	0.1%
Other values (3778)	50333	98.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
labels	2385	1.0%
recycled	2291	1.0%
color	2187	0.9%
with	2177	0.9%
set	2106	0.9%
blue	2092	0.9%
durable	2072	0.9%
black	2055	0.9%
avery	1920	0.8%
clear	1893	0.8%
Other values (2826)	210320	90.9%

Most occurring characters

Value	Count	Frequency (%)
	179838	11.4%
e	154618	9.8%
a	94421	6.0%
r	91563	5.8%
o	88370	5.6%
l	79902	5.0%
i	79392	5.0%
n	68089	4.3%
t	62491	3.9%
s	60638	3.8%
Other values (75)	623330	39.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1084788	68.5%
Uppercase Letter	235084	14.9%
Space Separator	180265	11.4%
Other Punctuation	50142	3.2%
Decimal Number	25561	1.6%
Dash Punctuation	6566	0.4%
Final Punctuation	67	< 0.1%
Open Punctuation	60	< 0.1%
Close Punctuation	60	< 0.1%
Math Symbol	35	< 0.1%
Other values (2)	24	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	154618	14.3%
a	94421	8.7%
r	91563	8.4%
o	88370	8.1%
l	79902	7.4%
i	79392	7.3%
n	68089	6.3%
t	62491	5.8%
s	60638	5.6%
c	43284	4.0%
Other values (18)	262020	24.2%

Value	Count	Frequency (%)
S	33233	14.1%
C	27670	11.8%
B	22724	9.7%
P	18037	7.7%
E	12943	5.5%
A	12468	5.3%
F	12209	5.2%
M	10589	4.5%
R	10364	4.4%
T	10107	4.3%
Other values (16)	64740	27.5%

Value	Count	Frequency (%)
,	44416	88.6%
/	1561	3.1%
&	1446	2.9%
"	1300	2.6%
.	998	2.0%
'	257	0.5%
#	90	0.2%
%	45	0.1%
!	9	< 0.1%
*	9	< 0.1%
Other values (2)	11	< 0.1%

Value	Count	Frequency (%)
1	5377	21.0%
0	5118	20.0%
5	3094	12.1%
2	2756	10.8%
3	2628	10.3%
8	1808	7.1%
4	1725	6.7%
9	1234	4.8%
6	941	3.7%
7	880	3.4%

Value	Count	Frequency (%)
	179838	99.8%
	427	0.2%

Value	Count	Frequency (%)
-	6566	100.0%

Value	Count	Frequency (%)
“	19	100.0%

Value	Count	Frequency (%)
”	67	100.0%

Value	Count	Frequency (%)
¾	5	100.0%

Value	Count	Frequency (%)
(	60	100.0%

Value	Count	Frequency (%)
)	60	100.0%

Value	Count	Frequency (%)
+	35	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1319872	83.4%
Common	262780	16.6%

Most frequent character per script

Value	Count	Frequency (%)
e	154618	11.7%
a	94421	7.2%
r	91563	6.9%
o	88370	6.7%
l	79902	6.1%
i	79392	6.0%
n	68089	5.2%
t	62491	4.7%
s	60638	4.6%
c	43284	3.3%
Other values (44)	497104	37.7%

Value	Count	Frequency (%)
	179838	68.4%
,	44416	16.9%
-	6566	2.5%
1	5377	2.0%
0	5118	1.9%
5	3094	1.2%
2	2756	1.0%
3	2628	1.0%
8	1808	0.7%
4	1725	0.7%
Other values (21)	9454	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1582117	> 99.9%
None	449	< 0.1%
Punctuation	86	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	179838	11.4%
e	154618	9.8%
a	94421	6.0%
r	91563	5.8%
o	88370	5.6%
l	79902	5.1%
i	79392	5.0%
n	68089	4.3%
t	62491	3.9%
s	60638	3.8%
Other values (69)	622795	39.4%

Value	Count	Frequency (%)
”	67	77.9%
“	19	22.1%

Value	Count	Frequency (%)
	427	95.1%
é	14	3.1%
¾	5	1.1%
à	3	0.7%

Sales
Real number (ℝ_≥0)

Distinct	27200
Distinct (%)	53.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	246.4905812
Minimum	0.444
Maximum	22638.48
Zeros	0
Zeros (%)	0.0%
Memory size	400.7 KiB

Quantile statistics

Minimum	0.444
5-th percentile	8.8
Q1	30.758625
median	85.053
Q3	251.0532
95-th percentile	1015.95564
Maximum	22638.48
Range	22638.036
Interquartile range (IQR)	220.294575

Descriptive statistics

Standard deviation	487.5653605
Coefficient of variation (CV)	1.978028362
Kurtosis	176.7311999
Mean	246.4905812
Median Absolute Deviation (MAD)	67.0062
Skewness	8.138080021
Sum	12642501.91
Variance	237719.9808
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.96	61	0.1%
15.552	41	0.1%
19.44	41	0.1%
10.368	37	0.1%
25.92	36	0.1%
32.4	34	0.1%
24	33	0.1%
17.52	31	0.1%
27.96	31	0.1%
45.36	25	< 0.1%
Other values (27190)	50920	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.444	1	< 0.1%
0.556	1	< 0.1%
0.836	1	< 0.1%
0.852	1	< 0.1%
0.876	1	< 0.1%

Value	Count	Frequency (%)
22638.48	1	< 0.1%
17499.95	1	< 0.1%
13999.96	1	< 0.1%
11199.968	1	< 0.1%
10499.97	1	< 0.1%

Quantity
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.476545136
Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Memory size	400.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	8
Maximum	14
Range	13
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.278766314
Coefficient of variation (CV)	0.6554686406
Kurtosis	2.27588873
Mean	3.476545136
Median Absolute Deviation (MAD)	1
Skewness	1.360367731
Sum	178312
Variance	5.192775913
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	12748	24.9%
3	9682	18.9%
1	8963	17.5%
4	6385	12.4%
5	4882	9.5%
6	3020	5.9%
7	2385	4.7%
8	1361	2.7%
9	987	1.9%
10	276	0.5%
Other values (4)	601	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8963	17.5%
2	12748	24.9%
3	9682	18.9%
4	6385	12.4%
5	4882	9.5%

Value	Count	Frequency (%)
14	186	0.4%
13	83	0.2%
12	176	0.3%
11	156	0.3%
10	276	0.5%

Discount
Real number (ℝ_≥0)

ZEROS

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1429075453
Minimum	0
Maximum	0.85
Zeros	29009
Zeros (%)	56.6%
Memory size	400.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.2
95-th percentile	0.6
Maximum	0.85
Range	0.85
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.2122799317
Coefficient of variation (CV)	1.485435434
Kurtosis	0.7166824085
Mean	0.1429075453
Median Absolute Deviation (MAD)	0
Skewness	1.387774552
Sum	7329.728
Variance	0.0450627694
Monotocity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	29009	56.6%
0.2	4998	9.7%
0.1	4068	7.9%
0.4	3177	6.2%
0.6	2006	3.9%
0.7	1786	3.5%
0.5	1633	3.2%
0.17	735	1.4%
0.47	725	1.4%
0.002	461	0.9%
Other values (19)	2692	5.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	29009	56.6%
0.002	461	0.9%
0.07	150	0.3%
0.1	4068	7.9%
0.15	459	0.9%

Value	Count	Frequency (%)
0.85	2	< 0.1%
0.8	316	0.6%
0.7	1786	3.5%
0.65	17	< 0.1%
0.602	23	< 0.1%

Profit
Real number (ℝ)

ZEROS

Distinct	28234
Distinct (%)	55.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	28.61098248
Minimum	-6599.978
Maximum	8399.976
Zeros	668
Zeros (%)	1.3%
Memory size	400.7 KiB

Quantile statistics

Minimum	-6599.978
5-th percentile	-83.90475
Q1	0
median	9.24
Q3	36.81
95-th percentile	211.5
Maximum	8399.976
Range	14999.954
Interquartile range (IQR)	36.81

Descriptive statistics

Standard deviation	174.3409719
Coefficient of variation (CV)	6.093498258
Kurtosis	291.4110896
Mean	28.61098248
Median Absolute Deviation (MAD)	15.96
Skewness	4.157188533
Sum	1467457.291
Variance	30394.77448
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	668	1.3%
7.92	64	0.1%
3.96	62	0.1%
4.32	60	0.1%
9	56	0.1%
2.88	55	0.1%
2.64	54	0.1%
5.28	52	0.1%
2.97	49	0.1%
4.92	48	0.1%
Other values (28224)	50122	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6599.978	1	< 0.1%
-4088.376	1	< 0.1%
-3839.9904	1	< 0.1%
-3701.8928	1	< 0.1%
-3399.98	1	< 0.1%

Value	Count	Frequency (%)
8399.976	1	< 0.1%
6719.9808	1	< 0.1%
5039.9856	1	< 0.1%
4946.37	1	< 0.1%
4630.4755	1	< 0.1%

Shipping Cost
Real number (ℝ_≥0)

Distinct	16753
Distinct (%)	32.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	26.47856704
Minimum	1.002
Maximum	933.57
Zeros	0
Zeros (%)	0.0%
Memory size	400.7 KiB

Quantile statistics

Minimum	1.002
5-th percentile	1.32
Q1	2.61
median	7.79
Q3	24.45
95-th percentile	111.4095
Maximum	933.57
Range	932.568
Interquartile range (IQR)	21.84

Descriptive statistics

Standard deviation	57.25137324
Coefficient of variation (CV)	2.162177929
Kurtosis	50.1458447
Mean	26.47856704
Median Absolute Deviation (MAD)	6.07
Skewness	5.872860637
Sum	1358085.703
Variance	3277.719738
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.35	113	0.2%
1.97	108	0.2%
1.8	106	0.2%
1.79	106	0.2%
1.62	105	0.2%
1.71	103	0.2%
2.04	103	0.2%
1.94	103	0.2%
1.98	102	0.2%
1.58	100	0.2%
Other values (16743)	50241	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.002	1	< 0.1%
1.003	1	< 0.1%
1.01	6	< 0.1%
1.019	1	< 0.1%
1.02	6	< 0.1%

Value	Count	Frequency (%)
933.57	1	< 0.1%
923.63	1	< 0.1%
915.49	1	< 0.1%
910.16	1	< 0.1%
903.04	1	< 0.1%

Order Priority
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	400.7 KiB

Medium	29433
High	15501
Critical	3932
Low	2424

Length

Max length	8
Median length	6
Mean length	5.4070969
Min length	3

Characters and Unicode

Total characters	277330
Distinct characters	18
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	High
2nd row	Critical
3rd row	Medium
4th row	Medium
5th row	Critical

Value	Count	Frequency (%)
Medium	29433	57.4%
High	15501	30.2%
Critical	3932	7.7%
Low	2424	4.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
medium	29433	57.4%
high	15501	30.2%
critical	3932	7.7%
low	2424	4.7%

Most occurring characters

Value	Count	Frequency (%)
i	52798	19.0%
M	29433	10.6%
e	29433	10.6%
d	29433	10.6%
u	29433	10.6%
m	29433	10.6%
H	15501	5.6%
g	15501	5.6%
h	15501	5.6%
C	3932	1.4%
Other values (8)	26932	9.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	226040	81.5%
Uppercase Letter	51290	18.5%

Most frequent character per category

Value	Count	Frequency (%)
i	52798	23.4%
e	29433	13.0%
d	29433	13.0%
u	29433	13.0%
m	29433	13.0%
g	15501	6.9%
h	15501	6.9%
r	3932	1.7%
t	3932	1.7%
c	3932	1.7%
Other values (4)	12712	5.6%

Value	Count	Frequency (%)
M	29433	57.4%
H	15501	30.2%
C	3932	7.7%
L	2424	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	277330	100.0%

Most frequent character per script

Value	Count	Frequency (%)
i	52798	19.0%
M	29433	10.6%
e	29433	10.6%
d	29433	10.6%
u	29433	10.6%
m	29433	10.6%
H	15501	5.6%
g	15501	5.6%
h	15501	5.6%
C	3932	1.4%
Other values (8)	26932	9.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	277330	100.0%

Most frequent character per block

Value	Count	Frequency (%)
i	52798	19.0%
M	29433	10.6%
e	29433	10.6%
d	29433	10.6%
u	29433	10.6%
m	29433	10.6%
H	15501	5.6%
g	15501	5.6%
h	15501	5.6%
C	3932	1.4%
Other values (8)	26932	9.7%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Postal Code	City	State	Country	Region	Market	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit	Shipping Cost	Order Priority
0	40098	CA-2014-AB10015140-41954	2014-11-11	2014-11-13	First Class	AB-100151402	Aaron Bergman	Consumer	73120.0	Oklahoma City	Oklahoma	United States	Central US	USCA	TEC-PH-5816	Technology	Phones	Samsung Convoy 3	221.980	2	0.0	62.1544	40.77	High
1	26341	IN-2014-JR162107-41675	2014-02-05	2014-02-07	Second Class	JR-162107	Justin Ritter	Corporate	NaN	Wollongong	New South Wales	Australia	Oceania	Asia Pacific	FUR-CH-5379	Furniture	Chairs	Novimex Executive Leather Armchair, Black	3709.395	9	0.1	-288.7650	923.63	Critical
2	25330	IN-2014-CR127307-41929	2014-10-17	2014-10-18	First Class	CR-127307	Craig Reiter	Consumer	NaN	Brisbane	Queensland	Australia	Oceania	Asia Pacific	TEC-PH-5356	Technology	Phones	Nokia Smart Phone, with Caller ID	5175.171	9	0.1	919.9710	915.49	Medium
3	13524	ES-2014-KM1637548-41667	2014-01-28	2014-01-30	First Class	KM-1637548	Katherine Murray	Home Office	NaN	Berlin	Berlin	Germany	Western Europe	Europe	TEC-PH-5267	Technology	Phones	Motorola Smart Phone, Cordless	2892.510	5	0.1	-96.5400	910.16	Medium
4	47221	SG-2014-RH9495111-41948	2014-11-05	2014-11-06	Same Day	RH-9495111	Rick Hansen	Consumer	NaN	Dakar	Dakar	Senegal	Western Africa	Africa	TEC-CO-6011	Technology	Copiers	Sharp Wireless Fax, High-Speed	2832.960	8	0.0	311.5200	903.04	Critical
5	22732	IN-2014-JM156557-41818	2014-06-28	2014-07-01	Second Class	JM-156557	Jim Mitchum	Corporate	NaN	Sydney	New South Wales	Australia	Oceania	Asia Pacific	TEC-PH-5842	Technology	Phones	Samsung Smart Phone, with Caller ID	2862.675	5	0.1	763.2750	897.35	Critical
6	30570	IN-2012-TS2134092-41219	2012-11-06	2012-11-08	First Class	TS-2134092	Toby Swindell	Consumer	NaN	Porirua	Wellington	New Zealand	Oceania	Asia Pacific	FUR-CH-5378	Furniture	Chairs	Novimex Executive Leather Armchair, Adjustable	1822.080	4	0.0	564.8400	894.77	Critical
7	31192	IN-2013-MB1808592-41378	2013-04-14	2013-04-18	Standard Class	MB-1808592	Mick Brown	Consumer	NaN	Hamilton	Waikato	New Zealand	Oceania	Asia Pacific	FUR-TA-3764	Furniture	Tables	Chromcraft Conference Table, Fully Assembled	5244.840	6	0.0	996.4800	878.38	High
8	40099	CA-2014-AB10015140-41954	2014-11-11	2014-11-13	First Class	AB-100151402	Aaron Bergman	Consumer	73120.0	Oklahoma City	Oklahoma	United States	Central US	USCA	FUR-BO-5957	Furniture	Bookcases	Sauder Facets Collection Library, Sky Alder Finish	341.960	2	0.0	54.7136	25.27	High
9	36258	CA-2012-AB10015140-40974	2012-03-06	2012-03-07	First Class	AB-100151404	Aaron Bergman	Consumer	98103.0	Seattle	Washington	United States	Western US	USCA	FUR-CH-4421	Furniture	Chairs	Global Push Button Manager's Chair, Indigo	48.712	1	0.2	5.4801	11.13	High

Last rows

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Postal Code	City	State	Country	Region	Market	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit	Shipping Cost	Order Priority
51280	35112	CA-2014-ZD21925140-41829	2014-07-09	2014-07-09	Same Day	ZD-219251408	Zuschuss Donatelli	Consumer	32216.0	Jacksonville	Florida	United States	Southern US	USCA	OFF-PA-6474	Office Supplies	Paper	Xerox 1921	15.984	2	0.2	4.9950	2.010	Medium
51281	6039	MX-2015-HG1502518-42164	2015-06-09	2015-06-11	First Class	HG-1502518	Hunter Glantz	Consumer	NaN	Bragança Paulista	São Paulo	Brazil	South America	LATAM	OFF-PA-4475	Office Supplies	Paper	Green Bar Message Books, Multicolor	84.000	5	0.0	9.2000	1.019	High
51282	24175	IN-2015-DB132707-42221	2015-08-05	2015-08-10	Standard Class	DB-132707	Deborah Brumfield	Home Office	NaN	Townsville	Queensland	Australia	Oceania	Asia Pacific	OFF-BI-3253	Office Supplies	Binders	Avery Binder, Economy	58.050	5	0.1	19.9500	1.010	Medium
51283	24105	IN-2015-KH1633058-42154	2015-05-30	2015-05-30	Same Day	KH-1633058	Katharine Harms	Corporate	NaN	Lucknow	Uttar Pradesh	India	Southern Asia	Asia Pacific	OFF-PA-4007	Office Supplies	Paper	Eaton Parchment Paper, Premium	26.940	2	0.0	1.8600	1.010	High
51284	9922	MX-2013-KM1637593-41636	2013-12-28	2013-12-31	First Class	KM-1637593	Katherine Murray	Home Office	NaN	Managua	Managua	Nicaragua	Central America	LATAM	OFF-PA-5876	Office Supplies	Paper	SanDisk Message Books, 8.5 x 11	18.640	1	0.0	8.0000	1.010	Medium
51285	29002	IN-2015-KE1642066-42174	2015-06-19	2015-06-19	Same Day	KE-1642066	Katrina Edelman	Corporate	NaN	Kure	Hiroshima	Japan	Eastern Asia	Asia Pacific	OFF-FA-3072	Office Supplies	Fasteners	Advantus Thumb Tacks, 12 Pack	65.100	5	0.0	4.5000	1.010	Medium
51286	34337	US-2014-ZD21925140-41765	2014-05-06	2014-05-10	Standard Class	ZD-219251408	Zuschuss Donatelli	Consumer	37421.0	Chattanooga	Tennessee	United States	Southern US	USCA	FUR-FU-4070	Furniture	Furnishings	Eldon Image Series Desk Accessories, Burgundy	16.720	5	0.2	3.3440	1.930	High
51287	31315	CA-2012-ZD21925140-41147	2012-08-26	2012-08-31	Second Class	ZD-219251404	Zuschuss Donatelli	Consumer	94109.0	San Francisco	California	United States	Western US	USCA	OFF-AR-5321	Office Supplies	Art	Newell 341	8.560	2	0.0	2.4824	1.580	High
51288	9596	MX-2013-RB1979518-41322	2013-02-17	2013-02-21	Standard Class	RB-1979518	Ross Baird	Home Office	NaN	Valinhos	São Paulo	Brazil	South America	LATAM	OFF-BI-2919	Office Supplies	Binders	Acco Index Tab, Economy	13.440	2	0.0	2.4000	1.003	Medium
51289	6147	MX-2013-MC1810093-41416	2013-05-22	2013-05-26	Second Class	MC-1810093	Mick Crebagga	Consumer	NaN	Tipitapa	Managua	Nicaragua	Central America	LATAM	OFF-PA-3990	Office Supplies	Paper	Eaton Computer Printout Paper, 8.5 x 11	61.380	3	0.0	1.8000	1.002	High

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters